home *** CD-ROM | disk | FTP | other *** search
/ ftp2.jacobs.com / 2015.02.ftp2.jacobs.com.tar / ftp2.jacobs.com / pub / iPass / Open Mobile-V2.3.0-11624-V9.000.msi / Data1.cab / _5708CA6059A4680905681E25498AE0B8 < prev    next >
Text File  |  2012-10-24  |  962b  |  32 lines
  1. ∩╗┐DROP TABLE NEPWIFI;
  2.  
  3. CREATE TABLE NEPWIFI (
  4. NEP_ID               INTEGER                        NOT NULL,
  5. DIRECTORY_ID         VARCHAR(255),
  6. DIRECTORY_PRIORITY   INTEGER,
  7. DIRECTORY_ACCOUNT    VARCHAR(80),
  8. MEDIA_TYPE           INTEGER,
  9. OWNER_ID             INTEGER,
  10. SUPPLIER_ID          INTEGER,
  11. DESCRIPTOR           VARCHAR(80),
  12. VERSION              INTEGER,
  13. STATUS               CHAR(1),
  14. SSID                 VARCHAR2(32),
  15. SSIDMASK             VARCHAR(32),
  16. SECURITY             INTEGER,
  17. BROADCAST            INTEGER,
  18. KEYINDEX             INTEGER,
  19. KEYVALUE             VARCHAR(64),
  20. CERTISSUEDTO         VARCHAR2(128),
  21. CERTISSUEDBYHASH     VARCHAR2(32),
  22. ISEELENABLED         CHAR(1),
  23. AUTH_METHOD_CODE     VARCHAR(64),
  24. PREFIX               VARCHAR(128),
  25. SUFFIX               VARCHAR(128),
  26. LOCALCONTENTURL         VARCHAR(2084),        
  27. PRIMARY KEY (NEP_ID)
  28. );
  29.  
  30.  
  31. DELETE FROM OM_DATABASE_VERSION;
  32. INSERT INTO OM_DATABASE_VERSION VALUES ('2.2');